import os

import pandas as pd

current_path = os.path.dirname(__file__)


def load_target_data():
    df1 = pd.read_excel(f"{current_path}/NACA 2414/Re=60400/UIUC_CS_Re60400.xlsx", engine='openpyxl')
    df2 = pd.read_excel(f"{current_path}/NACA 2414/Re=100800/UIUC_CS_Re100800.xlsx", engine='openpyxl')
    df3 = pd.read_excel(f"{current_path}/NACA 2414/Re=201600/UIUC_CS_Re201600.xlsx", engine='openpyxl')
    df4 = pd.read_excel(f"{current_path}/NACA 2414/Re=302700/UIUC_CS_Re302700.xlsx", engine='openpyxl')
    list_target = [df1, df2, df3, df4]

    return list_target


def load_source_data():
    df1 = pd.read_excel(f"{current_path}/NACA 2414/Re=60400/XFLR_Re60400.xlsx", engine='openpyxl')
    df2 = pd.read_excel(f"{current_path}/NACA 2414/Re=100800/XFLR_Re100800.xlsx", engine='openpyxl')
    df3 = pd.read_excel(f"{current_path}/NACA 2414/Re=201600/XFLR_Re201600.xlsx", engine='openpyxl')
    df4 = pd.read_excel(f"{current_path}/NACA 2414/Re=302700/XFLR_Re302700.xlsx", engine='openpyxl')
    list_source = [df1, df2, df3, df4]

    return list_source
